Skip to Content
0

what is the field separtor for space bar in fcc conversion

Nov 30, 2016 at 04:35 AM

56

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Raghuraman S Nov 30, 2016 at 05:00 AM
1

Hello Prabhakar,

Try using

0x20 or '0x20'

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0
Raghuraman S Nov 30, 2016 at 05:21 AM
0

can you post the FCC parameters screenshot.

Show 8 Share
10 |10000 characters needed characters left characters exceeded

These are my fcc parameters,

thanks,

s.prabhakar.

vij1z.png (12.7 kB)
xarhg.png (2.7 kB)
0

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.

0

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.

0

Hello Prabhkar,

Be clear with the scenario.

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

0

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.

0

Hello Prabhakar,

You can count this at the mapping level.

Is there a mapping program?

0
Show more comments
Evgeniy Kolmakov Nov 30, 2016 at 07:09 AM
0

Hi Prabhakar!

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

Regards, Evgeniy.

Show 4 Share
10 |10000 characters needed characters left characters exceeded

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.

0

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

Regards, Evgeniy.

0

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

0

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.

0
Evgeniy Kolmakov Dec 01, 2016 at 04:52 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded