Hi , @hninyuaung
According to your description, you want to convert the "Floor: 09\n\nUnit: 04\n\nBuilding Name (Optional): Fernwood Towers" to :
Floor is 09
Unit is 04
Building name is Fernwood Towers
Here are the steps you can refer to :
(1)This is my test json to test by creating in the compose action:
json('{
"body":{},
"value":[{
"X_Intake_Forms" : "Floor: 09\n\nUnit: 04\n\nBuilding Name (Optional): Fernwood Towers"
}]
}
')
(2)We can use this code to split this Text by '\n\n':
split( outputs('Compose')?['value']?[0]?['X_Intake_Forms'], decodeUriComponent('%0A%0A') )
(3)Then we can use the "Select" action to convert this array to the new array we want to like this:
concat(split(item(),':')[0],' is',split(item(),':')[1])
The result is as follows:
If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.
Best Regards,
Yueyun Zhang
