what is the field separtor for space bar in fcc conversion

[Former Member]

Hello All,

What is the filed separator for space abr between fields, traied with 0x09, ' ', and '' ''.

i copied space bar space from note pad also. but it not working.

could you please help me what is field separator for space bar.

Thanks and Regards,

s.prabhakar.

[former_member186851]

Hello Prabhakar,

Try using

0x20 or '0x20'

[Former Member]

Hi raghuraman,

That is for tab delimeter right, i used that one also but not working.

my file like

abc 123 xyz

sdf 567 bgh

is it any data types we need to change in data types, i am using type is xsd: string.

help me.

thnaks,

s.prabhakr.

[former_member190293]

Hi Prabhakar!

I will ask the same question again: what's your aim? Since you work with PI environment you deal with interfaces, messages, data types. What will you do with results of your counting? Do you need to include that result to target message?

Regards, Evgeniy.

[former_member190293]

Hi Prabhakar!

As Raghu has already said, '0x20' is the value of "fieldSeparator" parameter in case of space-delimeted file.

Regards, Evgeniy.

[Former Member]

Hi Evgeniy,

My scenario is count all charecters in file with huge data. how can i create data type structure at sender and recievr side.

please post me data structure and mapping to achive this scenario.

post me links or documents on this scenario.

Really i am facing new challenges every time.

please post your valuable comments.

Thanks,

s.prabhakr.

[former_member190293]

Wouldn't you please explain this requirement: why do you need to count characters? What's the aim?

Regards, Evgeniy.

[Former Member]

Hello Evgeniy,

This is the task given by one of my pi consultant.

to count all charecters in file. i never did like this type of scenarios.

so how can i achive this task requirement.

Thanks,

s.prabhakar

[former_member186851]

Hello Prabhkar

As Eve said firstly get the information why its required.Might be we can get the all the characters in a field and count or count using UDF.

[former_member186851]

can you post the FCC parameters screenshot.

[Former Member]

These are my fcc parameters,

thanks,

s.prabhakar.

[former_member186851]

Hello Prabhkar,

Confirm if the fields are separatred by space only.

0x20 is only for space and 0x09 is for Tab.

Do the change activate,Stop/Start channel and check.

[Former Member]

Hello Raghuramn,

actuvally my scenario is to count the charecters in file.

But when i am push the file it going to recievr but charecter count is showing 0. i am not getting charecters length,

is it file structure issue. i am having 4 input fileds and one output field(charecter_length).

Help me.

Thanks,

s.prabhakar.

[former_member186851]

Hello Prabhkar,

Be clear with the scenario.

To count each rows of characters you need to get it in a field then count it.

[Former Member]

Hi Raghuramsn,

Thanks for spending your valuble time to me.

now i am processing only first record like this.

abcd 1234 xyz.

But count is 0. it should come total charecters count.

i used Module transformation bean also for this one. my one of my pi consultant told it is not field separator issue.

i am in confussion, how to do it.

Thanks,

s.prabhakar.

[former_member186851]

Hello Prabhakar,

You can count this at the mapping level.

Is there a mapping program?

[Former Member]

Hello Raghuraman,

as you suggested 0x20 is working fine .

my problem is if i push one text file with data. i want to count total file charecters count. i want to know how do mapping at mapping level.

To count all charecters in file. i dont know how to take data types in IR to do mapping. earliyar i created source side is 4 fields, recievr side side id is one filed.

That is only working for 4 fields data. so want to change my data types to count all charecters in file.

if you have nay document or step by step blog link share with me.

Thanks,

s.prabhakr

[Former Member]

I push one file with 104 charecters, but i got output as 248 charecters.

is it counting space also between fileds and rows.

if it will count how can i remove the space charecters count.

Thanks,

s.k.prabhakar