Difference between revisions of "Manuals/calci/REPLACEB"
Jump to navigation
Jump to search
| (9 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =REPLACEB(Old_Text, Start_Num, | + | <div style="font-size:30px">'''REPLACEB (Old_Text,Start_Num,Num_Chars,New_Text) '''</div><br/> |
| − | + | *where, '''Old_Text''' is the original or old text | |
| − | + | *'''Start_Num''' represents the character position in old text | |
| − | * | + | *'''Num_Chars''' represents the number of characters to be replaced in old text |
| − | * | + | *'''New_Text''' is the new text with which specified number of characters in old text are replaced |
| − | * | + | **REPLACEB(), replaces characters within text.REPLACEB is intended for use with languages that use the double-byte character set (DBCS). |
| − | |||
| − | REPLACEB() replaces | ||
== Description == | == Description == | ||
| Line 15: | Line 13: | ||
*This function counts and replaces specified number of byte characters with a new text string. | *This function counts and replaces specified number of byte characters with a new text string. | ||
*REPLACEB is intended for languages that use double-byte character set (DBCS). | *REPLACEB is intended for languages that use double-byte character set (DBCS). | ||
| − | *If | + | *If '''Start_Num''' < 1, Calci displays #N/A message. |
| − | *If | + | *If '''Num_Chars''' < 1, Calci displays #N/A message. |
== Examples == | == Examples == | ||
| Line 52: | Line 50: | ||
=REPLACEB(A2,2,1,"@") :Replaces first byte (2 characters) from old text with upper case "@". Returns '''@****''' as output. | =REPLACEB(A2,2,1,"@") :Replaces first byte (2 characters) from old text with upper case "@". Returns '''@****''' as output. | ||
=REPLACEB(A3,2,1,"aa") : Replaces 2nd character from old text with "aa". Returns '''SaaAR''' as output. | =REPLACEB(A3,2,1,"aa") : Replaces 2nd character from old text with "aa". Returns '''SaaAR''' as output. | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|BB-G5ucpy4I|280|center|REPLACEB}} | ||
== See Also == | == See Also == | ||
| Line 62: | Line 64: | ||
*[http://en.wikipedia.org/wiki/Autocorrection Find and Replace] | *[http://en.wikipedia.org/wiki/Autocorrection Find and Replace] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 16:14, 13 August 2018
REPLACEB (Old_Text,Start_Num,Num_Chars,New_Text)
- where, Old_Text is the original or old text
- Start_Num represents the character position in old text
- Num_Chars represents the number of characters to be replaced in old text
- New_Text is the new text with which specified number of characters in old text are replaced
- REPLACEB(), replaces characters within text.REPLACEB is intended for use with languages that use the double-byte character set (DBCS).
Description
For Example, REPLACEB("JOHN",2,1,"$") returns J$HN
- This function counts and replaces specified number of byte characters with a new text string.
- REPLACEB is intended for languages that use double-byte character set (DBCS).
- If Start_Num < 1, Calci displays #N/A message.
- If Num_Chars < 1, Calci displays #N/A message.
Examples
| ColumnA | ColumnB | ColumnC |
| 123456 | ||
| ***** | ||
| STAR | ||
=REPLACEB(A1,1,2,"*") : Replaces first two characters from old text with "*". Returns *3456 as output. =REPLACEB(A2,2,1,"@") :Replaces first byte (2 characters) from old text with upper case "@". Returns @**** as output. =REPLACEB(A3,2,1,"aa") : Replaces 2nd character from old text with "aa". Returns SaaAR as output.
Related Videos
See Also
References