Extracting Column data and splitting into multiple columns

[Anonymous]

Hi All,

I am facing a problem in splitting and extracting a column data (Special Value) separated by "|" into multiple columns. Below are the screenshots of my input file and the desire output.

Request you to suggest me the solution for the same :

Input File:

Desire Output:

Waiting for the reply.

Thanks,

Anurag Kumar

[ankit7359]

hi @anurag13_,

the easy solution is to use that extractdelimitedfields component...

I dont know what is the issue with the source file you are handling...???

i m however trying to solve the scenario.

Thanks,

Ankit

[Anonymous]

Hi Ankit,

Do u get any new solution for the same?

Thanks,

Anurag Kumar

[ankit7359]

Hi @anurag13_,

Greetings of the Day,

Wish u a merry Christmas,

Well i m sorry to say this but,I couldnt find any other solution for your scenario and when i tried with the usual ones(textractdelimitedfields or substring) -> it did not help as it was retrieving single character... 

Well lets not lose hope, give it a try and i m sure we will get a solution.

Thanks,

Ankit

[Anonymous]

Can you provide metadata for this components.

NPUT(EXCEL)---->>>OUTPUT(DELIMITED_FILE)------>>>OnSubJOBOK(Trigger)---->>>INPUT(DELIMITED_FILE)------->>>OUTPUT(EXCEL).

Regards,

Avinash

[akumar2301]

Try to use delimiter as "\\|". Will work as charm. Pipe is special char for Java

[akumar2301]

Use "\\|"

[ankit7359]

Hi @uganesh,

Greetings of the Day,

The input file is in Excel format where - in we cant use Extended CSV options like escape characters and text enclosing characters.That being the reason i had tested out a workaround process of dumping the excel content to CSV and then extracting the content to various fields.

Well i dont see any other workaround process, but if anyone has any ideas pls do share such that, we all might come to know where we might have missed and what we might missed.

Thanks,

Ankit

[akumar2301 · Accepted solution]

Hello Ankit ,

I am asking it use in tExtractDelimiterFields.

Field Separator as "\\|" instead of "|".

Hope this will help.

[ankit7359]

Hi @uganesh,

Superb!!!!...It works... Kudos to you man..!!!

I was completely ignoring that in textractdelimitedfields we can give escape character.!!!.. that was my mistake..

Maybe you can give a reply and ask @anurag13_ to try this out as well... 

Thanks,

Ankit.

[Anonymous]

Hi,

I have tried with your provided solution but the didnt get the desire output.
It would be great if you could share the screenshots of your solution for better understanding.


Thanks,
Anurag Kumar