Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Split rows of data after special characters

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
Labels (2)
13 Replies
Anonymous
Not applicable
Author

Hi, Sabrina..
Thank you..i already got the answer for my problem just now..
Thank you again for your helps.. Smiley Happy
Thanks,
Yana_Isma
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

Hi Sabrina,
Thank you so much for your help.
Regards,
zo
Anonymous
Not applicable
Author

Hi zo,
Could you please mark this topic as resolved?
Best regards
Sabrina