Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I'm loading some data from a csv-file. One of the columns includes email-addresses. Now I want to create a new column and want to delete every double characters and sort the rest alphabetically.
For example...
LOAD id,
timestamp,
email
FROM C:test.csv
(txt, utf8, embedded labels, delimiter is ',', msq);
I want:
LOAD id,
timestamp,
email,
sortedmail
FROM C:test.csv
(txt, utf8, embedded labels, delimiter is ',', msq);
in the first row there is in column "email" the value: waynetrain@whateverest.com...
I want in same row in column "sortedmail" the value: aeinrtwy
You can load your table and use an Order By E-mail.
Example:
Thanks for your reply... I think, I've explained it wrong...
I'm loading:
ID | Timestamp | |
384 | 2019-06-26 06:35:41 | waynetrain@whateverest.com |
and I want:
ID | Timestamp | sortedmail | |
384 | 2019-06-26 06:35:41 | waynetrain@whateverest.com | aeinrtwy |
I think you may need to attach what you have in the way of qvw file and possibly the csv file(s) as well on this one for someone to further help you.
Regards,
Brett