How to deal with this use case in Dynamic Expression?

[Former Member]

Hi,

We have a use case that remove the domain of a given URL.

For example,

Input:"http://www.xxx.com/sap/ap/ds/wd/doc/00145EF588E602DC88EDD117A0D74

0C7/DataPackageContent.xml?sap-client=001"

Output:"/sap/ap/ds/wd/doc/00145EF588E602DC88EDD117A0D740C7/DataPackageCo

ntent.xml?sap-client=001"

In this case, "http://www.xxx.com" is removed.

How to do this with dynamic expression?

Currently I thinked about a stupid solution for a limit of 128 length check:

=IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,9)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-8),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,10)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-9),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,11)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-10),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,12)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-11),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,13)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-12),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,14)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-13),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,15)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-14),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,16)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-15),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,17)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-16),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,18)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-17),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,19)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-18),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,20)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-19),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,21)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-20),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,22)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-21),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,23)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-22),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,24)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-23),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,25)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-24),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,26)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-25),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,27)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-26),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,28)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-27),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,29)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-28),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,30)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-29),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,31)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-30),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,32)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-31),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,33)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-32),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,34)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-33),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,35)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-34),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,36)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-35),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,37)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-36),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,38)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-37),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,39)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-38),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,40)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-39),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,41)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-40),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,42)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-41),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,43)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-42),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,44)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-43),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,45)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-44),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,46)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-45),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,47)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-46),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,48)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-47),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,49)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-48),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,50)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-49),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,51)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-50),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,52)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-51),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,53)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-52),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,54)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-53),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,55)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-54),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,56)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-55),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,57)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-56),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,58)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-57),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,59)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-58),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,60)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-59),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,61)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-60),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,62)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-61),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,63)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-62),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,64)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-63),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,65)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-64),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,66)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-65),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,67)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-66),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,68)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-67),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,69)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-68),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,70)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-69),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,71)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-70),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,72)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-71),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,73)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-72),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,74)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-73),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,75)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-74),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,76)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-75),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,77)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-76),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,78)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-77),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,79)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-78),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,80)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-79),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,81)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-80),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,82)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-81),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,83)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-82),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,84)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-83),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,85)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-84),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,86)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-85),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,87)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-86),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,88)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-87),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,89)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-88),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,90)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-89),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,91)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-90),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,92)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-91),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,93)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-92),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,94)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-93),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,95)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-94),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,96)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-95),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,97)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-96),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,98)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-97),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,99)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-98),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,100)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-99),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,101)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-100),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,102)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-101),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,103)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-102),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,104)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-103),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,105)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-104),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,106)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-105),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,107)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-106),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,108)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-107),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,109)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-108),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,110)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-109),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,111)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-110),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,112)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-111),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,113)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-112),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,114)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-113),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,115)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-114),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,116)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-115),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,117)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-116),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,118)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-117),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,119)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-118),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,120)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-119),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,121)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-120),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,122)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-121),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,123)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-122),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,124)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-123),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,125)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-124),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,126)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-125),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,127)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-126),

IF(AT(@FileContentURI_Document_DataPackageAttachmentFolder,128)=='/',RIGHT(@FileContentURI_Document_DataPackageAttachmentFolder,Len(@FileContentURI_Document_DataPackageAttachmentFolder)-127),

@FileContentURI_Document_DataPackageAttachmentFolder))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Since Dynamic Expressions do not support loop functionality nor indexOf.

Moreover, they don't support wildcards and RegExp.

Do you have any good idea how to implement this?

[Former Member · Accepted solution]

Hi Shawn,

You can solve this in VC by creating a loop using a spinner.

Create a form and signal in and signal out to the form with the same name.

Add numeric (NUM1) and textual (STR1) fields to the signals.

In the form configuration, change the numeric field to spinner.

Add a custom action go to it.

Set the event to the the signal out with go event and add a gaurd condition left(@STR1,1)!="/"

Set the mapping:

@NUM1+1 -> NUM1

RIGHT(@STR1,LEN(@STR1)-1)

See also:

Hope this helps,

Shay

[Former Member]

Generally this use case can not be solved smoothly since lack of VC funcationality. There are some workaround can cover it.

[former_member203343]

I suggest creating a web service that will do this for you. The best thing would be that the web service will get a RegExp as the pattern.

Natty

[Former Member]

Hi,

Can we create such webservice in VC?

Or can we call external webservice in VC?

Or such webservice totally has no relationship with VC and we have to create it and call it in external java/abap application?

Thanks and best regards,

Shawn

[former_member203343]

VC works with web services. You can create the WS, then create a WS system in theportal that points to the WS's WSDL fiile and then search for it in VC.