cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Basic string transformations not working

darshthakkar
Valued Contributor

Hi Team,

I observed that basic string transformations are not working, few of the scenarios have been listed below:

  1. Trimming spaces from the text
  2. Changing the text from uppercase to lowercase and vice-versa

I have used both the mapper and conditional snap however havenโ€™t found any luck to it.

Examples for the above-listed scenario:
(1) Text is Darsh and if I put the transformation to change this to uppercase, it should return DARSH however the end result remains as is

(2) Text is " Darsh", after using trim(), trimLeft(), trimRight(), the expected result should be โ€œDarshโ€ however the end result doesnโ€™t change.

Any help on this would be highly appreciated.

Regards,
Darsh

3 REPLIES 3

AleksandarAngel
Contributor III

Hello @darshthakkar,

Just tested quickly on my side, and the stated functions are working as expected.

image

Iโ€™m not sure what can cause this type of behavior.

If you resolve this please let us know about the cause.

Thanks! ๐Ÿ™‚
Aleksandar.

Thank you @AleksandarAngelevski for your quick response and testing it out.
Iโ€™m unsure why this is happening for me.

It doesnโ€™t work on mapper and conditional snap both. I was on a call with snapLogic support and we tested it out (while on a screenshare) and we observed the failure.

Will keep this thread posted as soon as we are able to resolve the issue and have a RCA.

Regards,
Darsh

darshthakkar
Valued Contributor

Seems like there is an issue with the data coming from upstream systems. I tried with a sample excel file and below is my output:

image
image

Both the mapper and conditional snap are working as expected.