IndexOf SubString - Revision history

Smtxwiki at 09:19, 8 February 2024

2024-02-08T09:19:50Z

← Older revision		Revision as of 11:19, 8 February 2024
Line 22:		Line 22:

	So we need al input after the first '>' and before the next '<'		So we need al input after the first '>' and before the next '<'
			<br><br>
			New method:<br>
			GetXmlProperty('#REPLACE-FORMFIELD-Testuploadedfilesattachmentemail\|\|Upload1FileForm\|\|#', '/A/text()') <br><br>

	~~New method:~~		Old Method: Substring('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#',LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','">')+2,LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','<')-LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','">')-2)
	~~GetXmlProperty('#REPLACE-FORMFIELD-Testuploadedfilesattachmentemail\|\|Upload1FileForm\|\|#', '/A/text()')~~

	Method 1: Substring('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#',LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','">')+2,LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','<')-LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','">')-2)

	sample form : http://dev.ssp7.smt-x.com/Forms/form.aspx?adminmode=1&id=428		sample form : http://dev.ssp7.smt-x.com/Forms/form.aspx?adminmode=1&id=428

Smtxwiki at 09:19, 8 February 2024

2024-02-08T09:19:17Z

← Older revision		Revision as of 11:19, 8 February 2024
Line 23:		Line 23:
	So we need al input after the first '>' and before the next '<'		So we need al input after the first '>' and before the next '<'

	Method 1: Substring('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#',LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','">')+2,LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','<')-LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','">')-2)		New method:
			GetXmlProperty('#REPLACE-FORMFIELD-Testuploadedfilesattachmentemail\|\|Upload1FileForm\|\|#', '/A/text()')

			Method 1: Substring('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#',LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','">')+2,LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','<')-LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction\|\|Upload01\|\|#','">')-2)

	sample form : http://dev.ssp7.smt-x.com/Forms/form.aspx?adminmode=1&id=428		sample form : http://dev.ssp7.smt-x.com/Forms/form.aspx?adminmode=1&id=428

Smtxwiki at 08:56, 13 June 2023

2023-06-13T08:56:29Z

← Older revision		Revision as of 10:56, 13 June 2023
Line 36:		Line 36:

	From 'blabla Eric', I want to keep everything after the space, so only 'Eric'		From 'blabla Eric', I want to keep everything after the space, so only 'Eric'
			SUBSTRING('#1#', INDEXOF('#1#', ' ') + 1)

Smtxwiki at 08:39, 13 June 2023

2023-06-13T08:39:05Z

← Older revision		Revision as of 10:39, 13 June 2023
Line 31:		Line 31:

	sample form : http://dev.ssp7.smt-x.com/Forms/form.aspx?adminmode=1&id=502		sample form : http://dev.ssp7.smt-x.com/Forms/form.aspx?adminmode=1&id=502


			== Example 3 : return all data after a space ==

			From 'blabla Eric', I want to keep everything after the space, so only 'Eric'

Smtxwiki: 1 revision imported

2020-05-25T20:44:29Z

1 revision imported

← Older revision	Revision as of 22:44, 25 May 2020
(No difference)

Smtxwiki at 12:57, 6 April 2018

2018-04-06T12:57:43Z

New page

== Example 1: I need from ‘Long_Long (personfield)’ everything before the first ‘\’. ==

So from this entry:
SMTX\DDEVILDER
I need:
SMTX

I would normally do:
SUBSTRING('#REPLACE-PERSONFIELD-RequestedFor-Login_Long#', 0, INDEXOF('#REPLACE-PERSONFIELD-RequestedFor-Login_Long#', '\'))

Bit the ‘\’ needs to be excepted (don’t ask me why-), so you need it twice:

SUBSTRING('#REPLACE-PERSONFIELD-RequestedFor-Login_Long#', 0, INDEXOF('#REPLACE-PERSONFIELD-RequestedFor-Login_Long#', '\\'))

== Example 2 : filename extraction ==

I need the filename of an uploaded file.
It will give this normally:
<A HREF="http://dev.ssp7.smt-x.com/Forms/UserFiles/Uploads/Temp/stf2cbxcypkywtnrmcqt2cjq.8797.richardGere2.psd" target="_blank">richardGere2.psd</A>

So we need al input after the first '>' and before the next '<'

Method 1: Substring('#REPLACE-FORMFIELD-testfilenameextraction||Upload01||#',LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction||Upload01||#','">')+2,LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction||Upload01||#','<')-LastIndexOf('#REPLACE-FORMFIELD-testfilenameextraction||Upload01||#','">')-2)

sample form : http://dev.ssp7.smt-x.com/Forms/form.aspx?adminmode=1&id=428

Method 2:
GetXmlProperty('#REPLACE-FORMFIELD-UploadXmlTest||fuXml||#', '/A/@HREF')

sample form : http://dev.ssp7.smt-x.com/Forms/form.aspx?adminmode=1&id=502