Questions tagged [string]
The string tag has no summary.
35 questions
0
votes
1
answer
952
views
Get number capital letters in a string using PowerShell
I have a string. For now lets go with $string="mFN6jTPx?!". I would like to be able to count how many capital letters there are. I have tried using ($string -cmatch '[A-Z]').length but that ...
- 87
2
votes
1
answer
358
views
Split delimited (, ; #) string using SPD 2013
Need support in splitting a text (Single line text field/Multi line text field- Plain Text) which has delimiters and create new items in other library/list.
Tried using sample SPD 2013 workflow, but ...
- 23
1
vote
0
answers
214
views
How to use currentCultureName in place of currentUICultureName for locale files spfx
We have a site with variations in SP2016, the display language is in "es-es" but the variation language is "en-us".
We add a webpart of spfx with locale resources for translate constants texts, and ...
- 11
1
vote
2
answers
2k
views
Excel/Powershell to extract substring from a URL
I want to extract root URL from full URL. how to extract that based on number of "/" in that.
for example:
https://teams.SharePoint.com/sites/site/communities/subsite
from this URL i want to extract ...
- 449
0
votes
1
answer
37
views
Workflow to automatically send an e-mail not running as field set to allow Multiple Selection for contact names cannot be read as 'String'
I set up a workflow to send an acknowledge e-mail to the submitter of a form plus 1 secondary contact - both e-mail contacts are specified in separate fields and are selected via people pickers (...
0
votes
1
answer
219
views
How to extract part of url parameter for search
Background
I have a site that stores archived data extracted from an old application environment (Lotus/IBM Notes). The data is stored as lots of individual .pdf files, 1 per record from the old ...
0
votes
1
answer
706
views
Powershell to replace string in snippet in default.aspx
I have a requirement to replace a style section by appending in a new @import url for every default.aspx page in our farm. The problem comes in because this area might look like:
<
- 345
1
vote
1
answer
797
views
PowerApps Alpha-Numeric Substitution
My company uses an alpha-numeric substitution function. For example, say 1=A, 2=B, 3=C ... 8=H, 9=I and 0=J. They then convert a date in international format (DDMMYY) using the substitution so that a ...
- 295
0
votes
1
answer
840
views
replace a SharePoint relative URL using powershell
I want to replace /sites/contoso RelativeURL with /teams/Int_Contoso using PowerShell. Is there any regular expression to achieve this as we have changed the destination URLs during migration and now ...
- 449
9
votes
1
answer
27k
views
JSON Column formatting - Joining values
Is there a different way to join/concatenate values from 2 single line columns into a 3rd column other than the way below?
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-...
- 818
0
votes
1
answer
832
views
How to split string condition on array with powershell script. Exporting SharePoint library data on csv file
i am trying export library data into CSV file. i had used string functionality on my script to get content. my script was working fine but i am getting output in single string (or) one column. My ...
- 115
0
votes
2
answers
2k
views
Extract text from document name using calculated column
I need to isolate parts of a document name so that the workflow (SPD 2010) can update respective metadata fields.
Doc Name is within the following format : yyyymmdd.xxxx.xxxxxxxx.xxxx.xxxxxxxx
The ...
- 3
2
votes
3
answers
966
views
6 digit ID SharePoint workflow
I currently have a workflow that creates an ID. (Put the actual listitem ID into another field). I put the listitem id into a variable and then apply this variable into my custom column. I am wanted ...
- 53
0
votes
2
answers
116
views
Javascript in CSR, Slice & Substr
I have the below function,which colors Title column in SP Online. I want to extract just the last 2 characters from "Period" and use it in the Switch case.
I tried Slice,Substr function but both didn'...
- 1,522
1
vote
2
answers
4k
views
Powershell For Loop to add a semicolon after each value [closed]
I want to loop through a collection of items and append semicolon after each item.
Example Output values from mycollection:
5590
6063
1213
Expected Output:
5590;6063;1213
Below is my code.
for (...
- 431
3
votes
4
answers
2k
views
JavaScript - Rearrange String order?
var date = $(this).attr("ows_Date");
My current code displays a string output: 2017-01-02
Is there a Javascript code where I can move the first 4 digit to the back? How do i turn it into 01-02-2017?
...
- 109
1
vote
1
answer
3k
views
REST API System.FormatException: Input string was not in a correct format
I've encountered a strange problem with Rest API. I use it to collect data from SharePoint to my report. It works fine for all libraries on my site except for one. String that I use:
https://<my ...
4
votes
3
answers
12k
views
String functions SharePoint Designer 2013 Workflow
I have the below string stored in a variable:
11608,613,12,12643,12644,12656
I want to extract each value before the comma and perform a set of actions.
How to extract each value from the string ...
- 1,522
0
votes
1
answer
4k
views
Remove a section of a string in xsl
So I am doing a project in Sharepoint 2010 environment. I have an xsl template to retrieve the value of a page url. Currently this is the value that is being returned.
http://sitebuilder2/corporate/...
- 143
2
votes
1
answer
71
views
Calculated Columns - IF statement to find all numbers inbetween a selected area
Since my title is unclear let me explain.
I'm currently trying to work out if I can use an IF statement to find numbers inbetween a selected amount.
Example:
=IF([Weeks Left]="1-12","coming soon",...
- 43
1
vote
1
answer
323
views
Custom Activity for String Replace
In SharePoint 2010 designer, there is no direct option to replace the string with some other values. but in 2013, this is available. Is there any option to make this activity? I a column which is ...
- 395
0
votes
2
answers
783
views
How to append to Event Attendee list using workflow
On a Sharepoint 2010 workflow, on List B, I want to look up the Attendees on a particular event in List A, append that list of users with the user who Created the list item in List B (CurrentItem:...
- 687
3
votes
2
answers
17k
views
Storing a dynamic variable for Workflow in SPD 2013
I am new to Share Point designer 2013. I would like to Store a value to a variable as follows:
Store 'field' in 'Variable'.
When compared in SPD 2007, there is "Build Dynamic String" under Actions. ...
- 53
0
votes
1
answer
56
views
Refinements on a string field
Can I split the value in a string field for the refinements?
For example If I have values on a string field that looks like: "ABC,DEF" when I apply the refinements to that field I obtain "ABC,DEF" as ...
- 918
1
vote
2
answers
104
views
Can I pull month and year from a date in a text string?
I had two calculated columns "Month" and "Year" that displayed forms grouped by these columns. They were calculated from the last modified column.
Using =TEXT(Modified,"yyyy") and
=TEXT(Modified,"...
- 13
0
votes
1
answer
96
views
Better Way To Find A String In A SubString In SharePoint EventReceiver
I am trying to create an EventReceiver that works for more than one Content Type. When new Content Types are added in future I need the EventReceiver to still keep working.
My content types will ...
- 2,267
2
votes
1
answer
1k
views
Remove characters in string - and add it to array - Regex - Powershell - Migration
I'm trying to migrate data from a Excel spreadsheet to user profile properties.
Data ex:
Energy & Resources;#67777;#Financial Services;#137;#Consumer Business & Transportation;#23;#Real ...
- 2,250
0
votes
1
answer
75
views
Sharepoint 2010 - Make assigning users easier
we are using Sharepoint 2010 and maintaining an Action Item/Issue tracker list (for a limited number of people, <10). To make assigning Action Items to users easier I want to implement to option to ...
- 1
3
votes
1
answer
8k
views
Sharepoint 2013 - How to lookup custom string in workflow task
I'm creating a workflow that assigns a task to a person. After that person completes the task, they are required to input a string of text (a server URL) before they can press "Approve." Once this is ...
- 203
-1
votes
1
answer
2k
views
Unable to use string functions in REST query
I am querying for duplication of column name in the web using REST query. My query is as per below:
http://siteCollection/sites/Project1/_api/Web/Fields?$select=InternalName&$filter=toupper(...
- 3,230
1
vote
1
answer
2k
views
SharePoint Designer Workflow extract part of URL
Reusable workflow (content type based) running on a Document set. I need to extract the name of the Parent Document set while a workflow is running on the documents inside a doc set.
I get the full ...
- 165
2
votes
2
answers
17k
views
How to add line-breaks into "Multiple lines of text" field when using ToString()
I have a list field of the type "Multiple Lines of Text". When I retrieve it in my code-behind using item["field"].ToString(), it prints out the text, but without line-breaks. How can I add line ...
- 153
1
vote
1
answer
3k
views
Convert Person/User Group to String
I am retrieving a list that contains Persons and would like to convert them to String, and also be able to count how many users are per list. The Person is retrieved as an Object. How can I solve this ...
- 11
0
votes
2
answers
3k
views
Workflow cannot find list item when column has blank string
I am working in SharePoint 2010 Enterprise, building a workflow in SharePoint Designer. I have a very simple custom list which has a "Single line of text" column called "ProcessedState". I am trying ...
- 189
1
vote
2
answers
4k
views
How to assign string to TaxonomyFieldValueCollection object?
holds the multiple values of the taxonomy field. I have a string like 2;#Department 2|c98ce851-88fd-41bc-a013-4a69dd6bae66 and assigning it using PopulateFromLabelGuidPairs() but I am not able to see ...
- 3,230