How to add delimeter in my return sql result
Question

Hi Everyone,


I need to query and return result from sql as below


WWWW|USA|18|happy|20201120

KKKKKKKKKK|UK|18|happy|20211120


How to make it to add the pipeline?

I need to query and export to a file.


Thank you



Solution

Hello @jing tung wong,

Please review attached oml and let me know if you have questions. 

I have referenced the OutSystemsSampleDataDB module's Sample_Employee table. 

Following is the output the logic will produce for the select few attributes I considered for the demo:

Hope this helps, 

Regards,

AJ

DelimiterDemo.oml

Hi AJ,


Thanks for ur help.. it is working. really appreciate.


Thank you

You are welcome Jing, please do close out the post as the Solution.

Regards,

AJ

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.