ReplaceOnMultipleValues ( Value ; Start ; NumberOfCharacters ; ReplacementText )

Execute "Replace ()" function on each line of multiple lines.

Average rating: 4.0 (3 votes) Log in to vote

Koji Takeuchi - Show more from this author
TonicNote, Inc.
https://tonicnote.com

Sample input:

ReplaceOnMultipleValues ( "aaa¶ccc¶bbb¶abc" ; 2 ; 1 ; "-" )

Sample output:

a-a
c-c
b-b
a-c

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
ReplaceOnMultipleValues ( Value ; Start ; NumberOfCharacters ; ReplacementText )
2017.03.24, Koji Takeuchi <takeuchi@nemoux.com>


description:
	Execute "Replace ()" function on each line of multiple lines.
	This function was created for the purpose like splitting text from fixed-length data like Firm-Banking data.
ex1:
	ReplaceOnMultipleValues ( "aaa¶ccc¶bbb¶abc" ; 2 ; 1 ; "-" )
	 -> "a-a¶c-c¶b-b¶a-c"
ex2:
	ReplaceOnMultipleValues ( "aaa¶ccc¶bbb¶abc" ; 2 ; -1 ; "," )
	 -> "a,aa¶c,cc¶b,bb¶a,bc"
*/

Let (
[
LIST =
	Value ;
START =
	GetAsNumber ( Filter ( Start ; "-0123456789" ) ) ;
NUM =
	GetAsNumber ( Filter ( NumberOfCharacters ; "-0123456789" ) ) ;
REPLACEMENT =
	ReplacementText ;
VALID =
	not IsEmpty ( LIST ) and
	not IsEmpty ( START ) and
	not IsEmpty ( NUM ) and
	not IsEmpty ( REPLACEMENT ) ;
CURRENTVALUE =
	GetValue ( LIST ; 1 ) ;
RESTVALUE =
	RightValues ( LIST ; ValueCount ( LIST ) - 1 ) ;
CURRENTREPLACED =
	Replace ( CURRENTVALUE ; START ; NUM ; REPLACEMENT )
] ;

Case (
	not VALID ;
	"?" ;
	ValueCount ( RESTVALUE ) > 0 ;
	CURRENTREPLACED & ¶ &
	ReplaceOnMultipleValues ( RESTVALUE ; START ; NUM ; REPLACEMENT ) ;
	CURRENTREPLACED
)

)

description:
Execute "Replace ()" function on each line of multiple lines.
This function was created for the purpose like splitting text from fixed-length data like Firm-Banking data.
ex1:
ReplaceOnMultipleValues ( "aaa¶ccc¶bbb¶abc" ; 2 ; 1 ; "-" )
-> "a-a¶c-c¶b-b¶a-c"
ex2:
ReplaceOnMultipleValues ( "aaa¶ccc¶bbb¶abc" ; 2 ; -1 ; "," )
-> "a,aa¶c,cc¶b,bb¶a,bc"

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ReplaceOnMultipleValues ( Value ; Start ; NumberOfCharacters ; ReplacementText )

Comments

Support this website.

Support this website.