You've two options to make that work.
1) Create qvds from your SQL datasource & apply the function while you load data from the qvd.
2) Use Load Statement before the Select statement from the SQL and use the function in the Load part of the script.
Load *, SubField(fieldname,':',1) as userid,SubField(fieldname,':',2) as Country;
SQL Select * from Database.tablename;
where fieldname is ofcourse the name of the field which contains ur string from which u like to extract the id & country.
I am almost there..
if I use Load *, SubField(fieldname,':',1) as userid,SubField(fieldname,':',2) as Country;
I am only getting 3 rows of results(don't know why) and there's a lot more.
So I used SubField(SubField(fieldname,','),':') as idmails; and the results where all separated in the same table like this:
Is there a way to exclude text strings(country code) from the list?