Hai, How do I do if I have a row of data such that 10.2.3.123 and I wanted it to be into a new column with : Column A | Column B | Column C | Column D 10 | 2 | 3 | 123 Would you mind to give me some advice? Thank You in Advance, ZO
Yes, Sabrina told you exactly what you need. Read the content which is actually delimited in a column and use this column in the mentioned component as input field. This content will be separated into new columns based in the delimiter (in your case the pipe).
hi, all.. i have tried the job using tFileInputDelimited which suggested before. Source = 18.104.22.168.5 in single row by excel. The problem is the output not exist at that column. Output = one| two| three| four| five 1 | 2 | 3 | 4 | 5 the output like image below :
Hi zo, Since tExtractdelimitedfields component uses regex to split a filed and the regex syntax uses special characters as operators, make sure to precede the regex operator you use as a field separator by a double backslash. For example, you have to use "\\|" instead of "|". Best regards Sabrina
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.